| Key Name |
Key Type |
Keys |
| SaTrans_SyAddressID_N_N_IDX |
Inversion Entry |
SyAddressID |
| SaTrans_CheckNo_N_N_IDX |
Inversion Entry |
CheckNumber |
| SaTrans_SaBillingBatchID_N_N_IDX |
Inversion Entry |
StudentAccountBatchBillingId |
| SaTrans_SaBillCode_N_N_IDX |
Inversion Entry |
BillingTransactionCode |
| SaTrans_Date_Sa1098T_Type_INCLUDE_N_N_idx |
Inversion Entry |
TransactionDate, SA1098T, Type |
| satrans_FaStudentAyPaymentPeriodId_N_N_IDX |
Inversion Entry |
StudentAcademicYearPaymentPeriodId |
| SaTrans_SaTuitionDiscountPolicyID_N_N_IDX |
Inversion Entry |
TuitionDiscountPolicyId |
| SaTrans_saCashDrawerSessionID_N_N_IDX |
Inversion Entry |
CashDrawerSessionId |
| SaTrans_SaACHBatchID_N_N_IDX |
Inversion Entry |
AchBatchFileId |
| SaTrans_BatchNo_N_N_IDX |
Inversion Entry |
BatchNumber |
| SaTrans_Date_N_N_IDX |
Inversion Entry |
TransactionDate |
| Nk_satrans_SyAddressId |
Inversion Entry |
SyAddressID |
| satrans_AdFeesId_N_N_IDX |
Inversion Entry |
StudentEnrollmentPeriodFeeId |
| SaTrans_AmAgencyCCID_N_N_IDX |
Inversion Entry |
AgencyBranchCreditCardId |
| SaTrans_OriginalSaTransId_N_N_IDX |
Inversion Entry |
OriginalStudentAccountTransactionId |
| SaTrans_AdCourseID_N_N_IDX |
Inversion Entry |
CourseId |
| SaTrans_SyCampusID_Date_N_N_IDX |
Inversion Entry |
TransactionDate |
| SaTrans_AdEnrollId_AdTermId_SaBillCode_Source_Type_Amount_SaTransID_U_N_IDX |
Alternate Key |
BillingTransactionCode, Source, ClassSectionId |
| SaTrans_SyStudentID_Date_AdTermID_Type_N_N_IDX |
Inversion Entry |
TransactionDate, Type |
| SaTrans_SaTransID_U_C_IDX |
PrimaryKey |
StudentAccountTransactionId |
| SaTrans_AdEnrollId_Date_N_N_IDX |
Inversion Entry |
TransactionDate, ClassSectionId |
| SaTrans_CheckStatus_CheckClearedDate_CheckNo_SaBankAccountID_N_N_IDX |
Inversion Entry |
CheckStatus, CheckClearedDate, CheckNumber |
| Nk_SaTransAdClassschedID |
Inversion Entry |
ClassSectionId |
| SaTrans_SyCampusID_SaBankDepID_Type_Ref_Source_SaTransID_U_N_IDX |
Alternate Key |
Type, Reference, Source, ClassSectionId |
| SaTrans_SyStudentID_TranNum_N_N_IDX |
Inversion Entry |
TransactionNumber |
| SaTrans_AdTermID_Date_Sa1098T_N_N_IDX |
Inversion Entry |
TransactionDate, SA1098T |
| SaTrans_PostDate_Source_SaBankAccountID_SaTransID_U_N_IDX |
Alternate Key |
PostDate, Source, ClassSectionId |
| SaTrans_SyCampusId_AdEnrollId_AdTermId_Type_Amount_Date_SaTransId_U_N_IDX |
Alternate Key |
Type, TransactionAmount, TransactionDate, ClassSectionId |
| Entity Name |
Type |
Cardinality |
Business Name |
VerbPhrase |
InversePhrase |
Foreign Keys |
Is Supertype |
| AchBatchFile |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
AchBatchFileId |
NO |
| BankAccount |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
BankAccountId |
NO |
| BankDeposit |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
BankDepositId |
NO |
| Campus |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CampusId |
NO |
| CashDrawerSession |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CashDrawerSessionId |
NO |
| ClassSection |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
ClassSectionId |
NO |
| CreditCardBatchTransaction |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CreditCardBatchTransactionId |
NO |
| CashDrawerSession |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CashDrawerSessionId |
NO |
| ClassSection |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
ClassSectionId |
NO |
| Course |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CourseId |
NO |
| StudentEnrollmentPeriodFee |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodFeeId |
NO |
| AgencyBranchCreditCard |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
AgencyBranchCreditCardId |
NO |
| StudentAcademicYearPaymentPeriod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentAcademicYearPaymentPeriodId |
NO |
| AchBatchFile |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
AchBatchFileId |
NO |
| CourseRefundPolicy |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CourseRefundPolicyId |
NO |
| PaidDisbursement |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
PaidDisbursementId |
NO |
| Refund |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
RefundId |
NO |
| Term |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TermId |
NO |
| Student |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentId |
NO |
| StudentAward |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentAwardId |
NO |
| StudentCreditCard |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentCreditCardId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodId |
NO |
| StudentEnrollmentPeriodFee |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodFeeId |
NO |
| StudentRevenueDetail |
Non-Identifying |
One To Zero or More |
|
|
|
StudentRevenueDetailId |
NO |
| Term |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TermId |
NO |